Tabela CO_DICTMEALORDERDAY

Definicja tabeli CO_DICTMEALORDERDAY

Name

CO_DICTMEALORDERDAY

Code

CO_DICTMEALORDERDAY

Comment

Tabela przechowywyjÄ?ca konfiguracjÄ? kolejno??ci zamawianych posi??k??w


Lista kolumn tabeli CO_DICTMEALORDERDAY

Name

Code

CO_DICTMEALORDERDAYID

CO_DICTMEALORDERDAYID

MEALTYPEID

MEALTYPEID

ORDERDAY

ORDERDAY

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

Co_DictKitchenId

Co_DictKitchenId

ORDERDEADLINE

ORDERDEADLINE

CORRECTIONDEADLINE

CORRECTIONDEADLINE


Kolumna CO_DICTMEALORDERDAYID tabeli CO_DICTMEALORDERDAY

Definicja kolumny CO_DICTMEALORDERDAYID tabeli CO_DICTMEALORDERDAY

Name

CO_DICTMEALORDERDAYID

Code

CO_DICTMEALORDERDAYID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz g????wny


Kolumna MEALTYPEID tabeli CO_DICTMEALORDERDAY

Definicja kolumny MEALTYPEID tabeli CO_DICTMEALORDERDAY

Name

MEALTYPEID

Code

MEALTYPEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

posi??ek, klucz obcy do tabeli MEALTYPE, wymagana unikalno??Ä? warto??ci


Kolumna ORDERDAY tabeli CO_DICTMEALORDERDAY

Definicja kolumny ORDERDAY tabeli CO_DICTMEALORDERDAY

Name

ORDERDAY

Code

ORDERDAY

Data Type

NUMBER(5)

Mandatory

Yes

Comment

kolejno??Ä? zamawianych posi??k??w


Kolumna INSERTDATE tabeli CO_DICTMEALORDERDAY

Definicja kolumny INSERTDATE tabeli CO_DICTMEALORDERDAY

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_DICTMEALORDERDAY

Definicja kolumny INSERTINGPERSON tabeli CO_DICTMEALORDERDAY

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_DICTMEALORDERDAY

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_DICTMEALORDERDAY

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_DICTMEALORDERDAY

Definicja kolumny LASTMODIFIEDDT tabeli CO_DICTMEALORDERDAY

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Co_DictKitchenId tabeli CO_DICTMEALORDERDAY

Definicja kolumny Co_DictKitchenId tabeli CO_DICTMEALORDERDAY

Name

Co_DictKitchenId

Code

Co_DictKitchenId

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator kuchni


Kolumna ORDERDEADLINE tabeli CO_DICTMEALORDERDAY

Definicja kolumny ORDERDEADLINE tabeli CO_DICTMEALORDERDAY

Name

ORDERDEADLINE

Code

ORDERDEADLINE

Data Type

DATE

Mandatory

No

Comment

Limit czasowy zamowienia posilku


Kolumna CORRECTIONDEADLINE tabeli CO_DICTMEALORDERDAY

Definicja kolumny CORRECTIONDEADLINE tabeli CO_DICTMEALORDERDAY

Name

CORRECTIONDEADLINE

Code

CORRECTIONDEADLINE

Data Type

DATE

Mandatory

No

Comment

correction deadline


Lista kluczy tabeli CO_DICTMEALORDERDAY

Name

Code

Primary

PK_CO_DICTMEALORDERDAY

PK_CO_DICTMEALORDERDAY

X


Klucz PK_CO_DICTMEALORDERDAY tabeli CO_DICTMEALORDERDAY

Definicja klucza PK_CO_DICTMEALORDERDAY tabeli CO_DICTMEALORDERDAY

Name

PK_CO_DICTMEALORDERDAY

Code

PK_CO_DICTMEALORDERDAY

Primary

Yes

Comment